UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ShMwPBYGcOs7DB5v70k8hFUG9UHsoSNfm6P7jvXpxW0='
WHERE
key_id = '190924c823b502adc80769890f3785c115174e67b30b4bf5014997634798b647'
AND (
token = 'ShMwPBYGcOs7DB5v70k8hFUG9UHsoSNfm6P7jvXpxW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)