UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2v90B8gSRZEN+yf/GEXkyEdsu6Of2BVuDUCt4ueEQ20='
WHERE
key_id = 'e866af2ac4ab9c08c12901913bdf866751e05e63de5d913ac8fbd3ae9bd5d3d3'
AND (
token = '2v90B8gSRZEN+yf/GEXkyEdsu6Of2BVuDUCt4ueEQ20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)