UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KX6yeD3/101e/3U+7bSvPKaGVxS/CaZSP8r6klQnlZk='
WHERE
key_id = '5783d07be632985f51c2d20e7eb9229a85c1923645f243aaf1cf391c6fb0e54b'
AND (
token = 'KX6yeD3/101e/3U+7bSvPKaGVxS/CaZSP8r6klQnlZk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)