UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6J5mxM8VUN6f9aQrWIdWxSdGUi1nsbH4IjFhBryuBRs='
WHERE
key_id = '7f93135a7caebff5780c56fcc062b2e0bd1c1ca523a74dc13dae48215273b03f'
AND (
token = '6J5mxM8VUN6f9aQrWIdWxSdGUi1nsbH4IjFhBryuBRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)