UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VChGiNb8JJBXDaqgHQcVmH4vx8mBSMLJbU8KigrkaCQ='
WHERE
key_id = '2b1227c850eeb5d0e5382f82679d6249ed53518ded168a559ad4b9a7ac745518'
AND (
token = 'VChGiNb8JJBXDaqgHQcVmH4vx8mBSMLJbU8KigrkaCQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)