UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2wLpgnz9FKM0dBHxvGdgkV/6kY5SDQ4ZlCyyIDNSRtM='
WHERE
key_id = '59413d5a8a6585ec6dd9af3699cb48ac7c84541d85a12fb8776d39738f321337'
AND (
token = '2wLpgnz9FKM0dBHxvGdgkV/6kY5SDQ4ZlCyyIDNSRtM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)