UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6KnN+zM81oIeZV0qfDKtCuEzrvFMrP/8pN+ioW2KlSI='
WHERE
key_id = '58243b6328ed8c3d035c9c104713dc15c731278fb6fa0858459ff4a0160f0d17'
AND (
token = '6KnN+zM81oIeZV0qfDKtCuEzrvFMrP/8pN+ioW2KlSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)