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