UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bPF73I16JEC0AwA0AbGx/e88J8wUTNahUbh5xVtW1Po='
WHERE
key_id = '8e66efff0f16f70047beadc7b884fa887864e11f1cb7308e7ce5cccf07809e17'
AND (
token = 'bPF73I16JEC0AwA0AbGx/e88J8wUTNahUbh5xVtW1Po='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)