UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3xrI5cadcB4e7IJFUKC3xz0QbiGuuy3e3aNp2v8olJE='
WHERE
key_id = '92ab6fc5d1c907f4942520ee4cfe22534dc2d0f8109860613e2f1ea909061e47'
AND (
token = '3xrI5cadcB4e7IJFUKC3xz0QbiGuuy3e3aNp2v8olJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)