UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KREdVqwmiZUzhH8PHFEW1himF0QuPC7i8LBHg18oP0M='
WHERE
key_id = '28f9fb0dd7a2dbd659fc359933d20f042aced30aead95056b0e292a12919e996'
AND (
token = 'KREdVqwmiZUzhH8PHFEW1himF0QuPC7i8LBHg18oP0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)