UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vkZctQCDARDavXQb+8tj84qV1bdxRVn1XnPT9iHRczY='
WHERE
key_id = 'd878973f88a6d8a87572ccb714db96b15ef34cef37d973cf39a539473bee35a9'
AND (
token = 'vkZctQCDARDavXQb+8tj84qV1bdxRVn1XnPT9iHRczY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)