UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LcL+C6lcaFkG0coY66W51CYMGOfB40+lIvIyDR9OFpw='
WHERE
key_id = 'd8b851838e7886f31e4f610957b66ed5bcd0d36b34ac309cc46d2f08f0512db6'
AND (
token = 'LcL+C6lcaFkG0coY66W51CYMGOfB40+lIvIyDR9OFpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)