UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gsjefRyM9YDAXkas+HL/8EbSE18ekbTWZBweq5IvQqk='
WHERE
key_id = '7036429913bbacada17a56f2a246ad673b4472552b3778a8b7d12cf6ae8e7968'
AND (
token = 'gsjefRyM9YDAXkas+HL/8EbSE18ekbTWZBweq5IvQqk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)