UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'noGqPqZE3+b123lIv88jOZI0OSMZz9j7BAolcpMi2m8='
WHERE
key_id = 'b1571f738e759a0a01b6bccd48ea023bf3816e31c32d0bfe4155147e99cd24a3'
AND (
token = 'noGqPqZE3+b123lIv88jOZI0OSMZz9j7BAolcpMi2m8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)