UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pIV0W9UzHJsxwQEzHYltRJ0vbpzgsVcLdhTHo6VrPDU='
WHERE
key_id = '04cd5c247d86da1d25f166f14335ddf415d0c43bd67e2803819f81dc48768944'
AND (
token = 'pIV0W9UzHJsxwQEzHYltRJ0vbpzgsVcLdhTHo6VrPDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)