UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1IV/ob89/NLL+2xli0RMwnkfTksPkX1v0Hn2w8FLkfU='
WHERE
key_id = '16ff2208d497b76427f0cd863a10c808738c473282efe091450d6e453acec3f5'
AND (
token = '1IV/ob89/NLL+2xli0RMwnkfTksPkX1v0Hn2w8FLkfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)