UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cRn4mUIw2YrWSanqDIe1wAflA7/Wd0gHeb9J+cRQAcc='
WHERE
key_id = 'e176383710f1087a1b0bef7cb52d5161be9151f5dcfbca7cd1b04f91f9af1377'
AND (
token = 'cRn4mUIw2YrWSanqDIe1wAflA7/Wd0gHeb9J+cRQAcc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)