UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3z+nyaBnWfroaOv9KBzWetXHiCcSns/R3xAs5QJ7KWA='
WHERE
key_id = 'bc6b95839b3404d64969381c57a0ed16c2d463d5ccb14b06560fd2eb08f70571'
AND (
token = '3z+nyaBnWfroaOv9KBzWetXHiCcSns/R3xAs5QJ7KWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)