UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dJfqqe11OzrU0R+1XLF2ojxMv+33hEvYkZ3up8pBGIE='
WHERE
key_id = 'd9ef81337711e0698d79151b7ae1131b0db8b314ba8d38d38662ab931055fde8'
AND (
token = 'dJfqqe11OzrU0R+1XLF2ojxMv+33hEvYkZ3up8pBGIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)