UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xnj2Hzgw0IGEd+g3wiAkryeOWqRyacFtFEV062bHrz0='
WHERE
key_id = '5ccc1f94fa2033fbe49fa6c64cd465d243f1e86b3e615c808b96a2d1ee05d135'
AND (
token = 'Xnj2Hzgw0IGEd+g3wiAkryeOWqRyacFtFEV062bHrz0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)