UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'puIeCnVJWxsNMRScCBZ0nH4Dk1wWYHX8HHRV5t6nh+0='
WHERE
key_id = 'b325a1e058ab309d4af6bf41c40e7f2ac1d9d113d1088ce1e0fb2b20c5d5040b'
AND (
token = 'puIeCnVJWxsNMRScCBZ0nH4Dk1wWYHX8HHRV5t6nh+0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)