UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l2hR467Bzu894WApyqIcQU0NMDnR27RUEskoLAB9NiI='
WHERE
key_id = 'e1dd567d3815544920ae9e64d14646c4bf906dbcbf5b5fa8101fece2bd6e0023'
AND (
token = 'l2hR467Bzu894WApyqIcQU0NMDnR27RUEskoLAB9NiI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)