UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I1KsECsqrSi+YjYxBxclQ07UbuOBLAGi9u/5Dk0uKgg='
WHERE
key_id = 'b1b1d9294749cac97a0d10b15a3cd75bc098b589ba6477602ca7d359b174166a'
AND (
token = 'I1KsECsqrSi+YjYxBxclQ07UbuOBLAGi9u/5Dk0uKgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)