UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y6GlwcKE4D7J7Sj/3c/ba0teM/aziIZmdVx70rBl20g='
WHERE
key_id = '038708489cf6bbacaf66b45ec7460b23b1de41da3814d45ef7deeb3c20058372'
AND (
token = 'y6GlwcKE4D7J7Sj/3c/ba0teM/aziIZmdVx70rBl20g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)