UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KPT19fyyZlKUcv7sn5nB2FzH06BuI22A6bV1MRguBEQ='
WHERE
key_id = '65a37c0805a5d2950784d2b185093d41930c394e0c4b11f4bc330eee6374ed30'
AND (
token = 'KPT19fyyZlKUcv7sn5nB2FzH06BuI22A6bV1MRguBEQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)