UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5xXHrztFHG+Y98iPXTU7bplSpTOHOAJq2PSsZzVUk8o='
WHERE
key_id = 'caeabe47c80ec592a0913da0ca4fb1f2c686c16a18786f38e870a967577d733b'
AND (
token = '5xXHrztFHG+Y98iPXTU7bplSpTOHOAJq2PSsZzVUk8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)