UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cLK+Tx2UQ/hZTabdO5cU7rat3fjrByt1/lKhyRTdFY8='
WHERE
key_id = 'a1afb99bf4391dfc4b7b6ead1b2c4e4efcf73def6d5a74f069eec86b1ccedcf7'
AND (
token = 'cLK+Tx2UQ/hZTabdO5cU7rat3fjrByt1/lKhyRTdFY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)