UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PIWpY2kHT5M5AEzI9yS3/3KHqoRO9MdE3a1J1eAJpfE='
WHERE
key_id = 'ec30686f59e91c0cb8cf4a4129cc158c072121ed0aee389569189f0f6ebdf13c'
AND (
token = 'PIWpY2kHT5M5AEzI9yS3/3KHqoRO9MdE3a1J1eAJpfE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)