UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WaBuZTKM1R4rlOLojyt5pXrhw0sH3GCGv6PUnSxCeB8='
WHERE
key_id = 'ad7c3a88e80e6bcaae4c46be28b7ad02453b5f3fe312fbe8c4cc42a47f232667'
AND (
token = 'WaBuZTKM1R4rlOLojyt5pXrhw0sH3GCGv6PUnSxCeB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)