UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/dRBQexhvnSqXDFRYt8ygD3IyFk1P8sa11r/NYr96cI='
WHERE
key_id = 'a8f18e3aa56093c90539d061b9aae5a10a8df65b6387876b5e45c417aa29110c'
AND (
token = '/dRBQexhvnSqXDFRYt8ygD3IyFk1P8sa11r/NYr96cI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)