UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sSHfhXn4qq4j/027KqjYnsQA/8vllIVksUTSw067yC8='
WHERE
key_id = 'a769e59cb36e7bdcecf164e471444c0399cfb4d67751ec266618b6ac3848b215'
AND (
token = 'sSHfhXn4qq4j/027KqjYnsQA/8vllIVksUTSw067yC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)