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