UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'thTiqv6lYItCNylBcxBufwGc6Y/+YN1gS3218Cfw0Nw='
WHERE
key_id = '50d7d61736bf5d6c35b6001e49a0225d104b3a3f4636c39fd9aedb61c7a2a4c7'
AND (
token = 'thTiqv6lYItCNylBcxBufwGc6Y/+YN1gS3218Cfw0Nw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)